UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cnnHdRmGkrExnpWuS986vBIYrJDncs7uTXA6EPkxl8U='
WHERE
key_id = 'ac8f0b79bfe279f6fd956d72485b90d99889d680bcbea24b54e16af4cf5a307a'
AND (
token = 'cnnHdRmGkrExnpWuS986vBIYrJDncs7uTXA6EPkxl8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)