UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nPzN7Mz3LYYqDuUdeIJ876Z7s6j8Qw5ymAZoZbzPYCU='
WHERE
key_id = '668b612b2d9eed49faee3ba5bdb005e26fbadf7570d8d66f75e20429d016bad2'
AND (
token = 'nPzN7Mz3LYYqDuUdeIJ876Z7s6j8Qw5ymAZoZbzPYCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)