UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aDACes+hsGW0Ip1ZXYnZmsKcytf430JR7AW02Y8p9zY='
WHERE
key_id = '4ec5c375c52f044ae96b59bb5ae566cd0710b6ff57be7b4a712950b0cc1fe07b'
AND (
token = 'aDACes+hsGW0Ip1ZXYnZmsKcytf430JR7AW02Y8p9zY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)