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