UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9w9SvrghYVnGNsKr9+0Ao0WETozk2wlxCz0H/snfB8='
WHERE
key_id = '73f80e245aa5974513c5da2afd8b69b4d1c3b435def4104e1b614c07da95678b'
AND (
token = 'J9w9SvrghYVnGNsKr9+0Ao0WETozk2wlxCz0H/snfB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)