UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'piYFe+fb20f+jvYxKqzTTQEqfKovpx4E71RrMaM8HBg='
WHERE
key_id = 'a78dda79e886a5b99353d63f04df1761022ad811b4bd7f9402c0580193a7cc76'
AND (
token = 'piYFe+fb20f+jvYxKqzTTQEqfKovpx4E71RrMaM8HBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)