UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6v0pvjoFKsI5UIkfxPJXsPkZT9LpyZE5QAgFZ7SykzM='
WHERE
key_id = '678d241085dacf8d49bb9b3d802f79c2659bcf61cfdb1d0b7439ca556eeac4a3'
AND (
token = '6v0pvjoFKsI5UIkfxPJXsPkZT9LpyZE5QAgFZ7SykzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)