UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hMZOpOQXLeFLYau4BHIrgIsSC8XhBhLMZi4kTBw/uGw='
WHERE
key_id = '136be37e0a22cd22efcc6a1e7316e3b00d3e2081f2becfca3717278fcfd163b0'
AND (
token = 'hMZOpOQXLeFLYau4BHIrgIsSC8XhBhLMZi4kTBw/uGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)