UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JJxwpngMFxAt0G6Yy/9cBEScg5p2cCWbfF5QrfyQxlE='
WHERE
key_id = 'b8b98b1ef84ca7ea245ef5af9a115a6813d8ac1f5e2fda34d7327387bf6f8965'
AND (
token = 'JJxwpngMFxAt0G6Yy/9cBEScg5p2cCWbfF5QrfyQxlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)