UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yOIl3Uitj9rarRENv7JEdBeaHYBDe8lfCYyRU73XAsE='
WHERE
key_id = '7dc6e1d018ce2dd50a36aa14a1ce8d1ebbffbcc3ad01c7605a779e4998042d2b'
AND (
token = 'yOIl3Uitj9rarRENv7JEdBeaHYBDe8lfCYyRU73XAsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)