UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FiiYiZGhIvpcS06PvgU1TB3qzeaVDIVsoGl3aWPcIqA='
WHERE
key_id = '3e2e345bf51c455550a7568abd9ed1754de7e2172f43c792592afbb09c94eec6'
AND (
token = 'FiiYiZGhIvpcS06PvgU1TB3qzeaVDIVsoGl3aWPcIqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)