UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0PrKsiz8iYJcYrEoGHrVApGK9hGlcMb29zQCYJeIrcY='
WHERE
key_id = 'ac1f82abcb4f8369f8d4914dec3d16ee648658f01c529c1ae79fc7972219a43c'
AND (
token = '0PrKsiz8iYJcYrEoGHrVApGK9hGlcMb29zQCYJeIrcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)