UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7qSQP0CWe5SUJby5wGyKyEmJBWw++eNOqiAUY4eBV48='
WHERE
key_id = '7d0b2fb3a5e7368eae39ff58418d38379d69bad1843777ea9b4673c3b7249349'
AND (
token = '7qSQP0CWe5SUJby5wGyKyEmJBWw++eNOqiAUY4eBV48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)