UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzSl/5OxJm6JsFLZ0OxOiNOQuioGpJoCLC92rAaZwpM='
WHERE
key_id = 'a522d172b47c1de68fcbe3ba6be31454adcfcd7c1acb7bd48bbf9e21b3b4b161'
AND (
token = 'pzSl/5OxJm6JsFLZ0OxOiNOQuioGpJoCLC92rAaZwpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)