UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mp2CLfBcFg8SsMfxAI7ks9Xty2/b/9uH8hUz4tPyH7k=' 
WHERE 
  key_id = 'af0f3345d2dd4a333f7115fb5c6b18197ad2d6db8d539b6fb3c75f4c64329137' 
  AND (
    token = 'mp2CLfBcFg8SsMfxAI7ks9Xty2/b/9uH8hUz4tPyH7k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031