UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'joTvLqWPZ9gYKHOYOUQY0pOATZT/dLtoKoss3RLwUoE='
WHERE
key_id = 'ab875dc564ffc70ac4d75a2fdde9b51057df1733e436fd7ca89f3c1f9c3e0fb6'
AND (
token = 'joTvLqWPZ9gYKHOYOUQY0pOATZT/dLtoKoss3RLwUoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)