UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pPtSJZv8pFZlQLxk4txVq0VQWNzwNHA2m3z11ocYZg='
WHERE
key_id = '654c9b567adb0bdde2792fa0415c978839df4840e74f666d6162bf6eadc13d0a'
AND (
token = '9pPtSJZv8pFZlQLxk4txVq0VQWNzwNHA2m3z11ocYZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)