UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jf6tbzHk1QPsItF8Zbrd2VpWZ/O6U5zoVwZQXy1oEHA='
WHERE
key_id = 'd5a766a53b56a65bc29f9c4bcb3adeaf785a370cbc2f727fc833f53a81f03fc3'
AND (
token = 'Jf6tbzHk1QPsItF8Zbrd2VpWZ/O6U5zoVwZQXy1oEHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)