UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPtdcUBv+a2zKZjAQRZawdHcKKMbmJVFE9OkEYZcui4='
WHERE
key_id = '3e78e056a0a9175ff979566fd09e527f9cd2e0e61c2459e15d4b49005c2f8ce1'
AND (
token = 'pPtdcUBv+a2zKZjAQRZawdHcKKMbmJVFE9OkEYZcui4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)