UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I8HLYMncI1uBfaJSa1ulUTTZt62JfEjqpINnlH9NNso='
WHERE
key_id = '6aae861b40ec4d961f03a74c2ea25c50cd425239de1fa9211242d5c7a07f0ade'
AND (
token = 'I8HLYMncI1uBfaJSa1ulUTTZt62JfEjqpINnlH9NNso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)