UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9rTsRgMxrRiFlRC8bWVRYrT0uRmfCNfxvv6dYtu14qI='
WHERE
key_id = '6181f175291b4faa036ae3fbd3356a482b3971d10e545080071ab99452367bcb'
AND (
token = '9rTsRgMxrRiFlRC8bWVRYrT0uRmfCNfxvv6dYtu14qI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)