UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xWZJqvn9gOp9tobJ5mLpInFzqFREma1mKE+UZPB9BS4='
WHERE
key_id = 'd8b7af9471a1bd54c53ec5fa0dbc66b2c950049f864ea152509da70432c4f6dc'
AND (
token = 'xWZJqvn9gOp9tobJ5mLpInFzqFREma1mKE+UZPB9BS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)