UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YJUZgrChSns2xcYYJkfJt8B14b03pR7ddpaTiLJmxiA='
WHERE
key_id = '476e3e6fbed1132e5f2f6083225a716efabca652d40915b5cbd3ca455b762cb1'
AND (
token = 'YJUZgrChSns2xcYYJkfJt8B14b03pR7ddpaTiLJmxiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)