UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '//X9dJ2tEFq609n6w8IMbq6SRZjapHUA3gWYPa0t2mc='
WHERE
key_id = '6218af911e1877372c4326edce308b4ed856378fc2525ff9002e456d57a44f3b'
AND (
token = '//X9dJ2tEFq609n6w8IMbq6SRZjapHUA3gWYPa0t2mc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)