UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4FGD+N+Nrw2iAHB7uKRAGTXvyZfIIY1qvDE5iVf72I='
WHERE
key_id = 'be814b2477e0f4e685edce545e05a609eb0afcf07463a8cda7178f6b04d8145d'
AND (
token = 'D4FGD+N+Nrw2iAHB7uKRAGTXvyZfIIY1qvDE5iVf72I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)