UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QRxjDorAL4J6JTI7ykp2J2LSM0588sS8ioB3SQgAYA0='
WHERE
key_id = '197f10f9ec3bd23006cd0b7f04ba7861abc2e486b55a95dbcd6d0b7d9e3077c9'
AND (
token = 'QRxjDorAL4J6JTI7ykp2J2LSM0588sS8ioB3SQgAYA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)