UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xz8GyKyBoUwdMUd/smIsFwMVXO1rCa6u3y3tiOs5C8g='
WHERE
key_id = '47a2ee0f79c9276ce496b02224498faff806ede885014aab086685e07ad8fa22'
AND (
token = 'xz8GyKyBoUwdMUd/smIsFwMVXO1rCa6u3y3tiOs5C8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)