UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJ0KWH0+UUp4TOUH96FWJeIk0JQcpC/d/2kLSP/1yW4='
WHERE
key_id = '1b9ffe55f4bdec238a7bb4539b39bdb84250456cc9ce33ce93eef202b26e5d5a'
AND (
token = 'XJ0KWH0+UUp4TOUH96FWJeIk0JQcpC/d/2kLSP/1yW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)