UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J2jtLjz10aVEFv++Fu8LFxlo/9+pq74T7dkLkJO+/uk='
WHERE
key_id = '24230f50fe5aea6f82197587a3021ec93550a09517aefb25223ea8ce94254670'
AND (
token = 'J2jtLjz10aVEFv++Fu8LFxlo/9+pq74T7dkLkJO+/uk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)