UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'plXqFcWMo5YX/IFQvouWZK6M/JDVgNtYvup1VmnBwM0='
WHERE
key_id = 'b4a842b892bcbe119e94615b2dc9c6c1c6d338ebd20ea40377099b9f01e53ee5'
AND (
token = 'plXqFcWMo5YX/IFQvouWZK6M/JDVgNtYvup1VmnBwM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)