UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd4bIj8w3Dg7hedz0ltvUjAdXDiaa0pSzAwXK7oDCDj4='
WHERE
key_id = '6da530c555d068c7b6ef6574e9d2fe0e04df1aa3a87997b7d78d469be96acf5e'
AND (
token = 'd4bIj8w3Dg7hedz0ltvUjAdXDiaa0pSzAwXK7oDCDj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)