UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VDd8paXqLQwNZ6yiKmF2jLXO3oxwH6wRWAC1ICE28PU='
WHERE
key_id = 'a8a8b695380e59eb416bdb2cc68eb0dbf7fb8f764be27864424eddd3bfed7ae5'
AND (
token = 'VDd8paXqLQwNZ6yiKmF2jLXO3oxwH6wRWAC1ICE28PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)