UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xB9Gahn0ASxByBWUIXRcXb47bEDJ7nExhy5fV/2Smj8='
WHERE
key_id = 'c98b48fd95821c3c693820ea146661fb36644ed78098963a270a5fd914625561'
AND (
token = 'xB9Gahn0ASxByBWUIXRcXb47bEDJ7nExhy5fV/2Smj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)