UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TX+c87zgKuI4HKpXfA9wplPhpHohBIBz2cPEGtO7Cfo='
WHERE
key_id = 'a18e44778a888388ee8ab247c6ba3dfd0a440d1306909409c884f2f904f5a11e'
AND (
token = 'TX+c87zgKuI4HKpXfA9wplPhpHohBIBz2cPEGtO7Cfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)