UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2YBo10oXwrTQS84xqbKaUKwMAJN50trG0pgHLr5e0u8='
WHERE
key_id = '31747a24648815bf17e17a928d0170887578e8a54317cf4e244ab8a3dceb0c97'
AND (
token = '2YBo10oXwrTQS84xqbKaUKwMAJN50trG0pgHLr5e0u8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)