UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bodYzhJCAeyNQq9G792rJ5vGSPa3fGvQXNLw07Al1ZM='
WHERE
key_id = '08e7ec583c5cda77e51762df3e98fecb1f010c7e52a28ec7ff26a903ef36f25e'
AND (
token = 'bodYzhJCAeyNQq9G792rJ5vGSPa3fGvQXNLw07Al1ZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)