UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AczWKtRHNVNWAFm9gYIYVSA7LMJx92sxH+ky1vuH7BI='
WHERE
key_id = 'ef8c9477c5a6bf97ddec9a36e75df973e05156457e51744223980a7d8d2b3aa5'
AND (
token = 'AczWKtRHNVNWAFm9gYIYVSA7LMJx92sxH+ky1vuH7BI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)