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