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